package org.code.mallspringboot.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.code.mallspringboot.pojo.SmsCouponHistory;

import java.util.List;

/**
 * @Entity org.code.mallspringboot.pojo.SmsCouponHistory
 */
@Mapper
public interface SmsCouponHistoryMapper {

    /**
     分页 + 查询
     * @param pageNum
     * @param pageSize
     * @param useStatus
     * @param orderSn
     * @param couponId
     * @return
     */
    List<SmsCouponHistory> selectPage(@Param("pageNum") Integer pageNum,
                                      @Param("pageSize") Integer pageSize,
                                      @Param("useStatus") Integer useStatus,
                                      @Param("orderSn") String orderSn,
                                      @Param("couponId") Integer couponId);

    /**
     总页数
     * @param useStatus
     * @param orderSn
     * @param couponId
     * @return
     */
    int total( @Param("useStatus") Integer useStatus,
               @Param("orderSn") String orderSn,
               @Param("couponId") Integer couponId);
}




